StoredValueInstrumentActivationAuthorization

Entity Definition

Logical Name : StoredValueInstrumentActivationAuthorization
Physical Name : TR_STRD_VL_INSTRMNT_ACV_AZN

Join entity that associates a StoredVaoueInstrument activation with a TenderAuthorization. Prepaid gift cards and other stored value media require authorization before thay may be used to purchase items. Activation incorporates authorization as part of its process similarly to the way credit and debit cards use authorization as a way to validate their use in a retail transaction.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
AuthorizationSequenceNumber (PK) Sequence number to identify the authorization attempt for a specific TenderLineItem. AI_AZN_SQN_NMB LineNumber smallint
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) StoredValueTransaction(TR_STRD_VL_TND_CTL_TRN)
TenderAuthorizationID (FK) A token identifier for a TenderAuthorization instance. AI_TND_AZN LineNumber smallint TenderAuthorization(CO_AZN_TND)

Relationships

Parent Entity Verb Phrase Child Entity
TenderAuthorization authorizes StoredValueInstrumentActivationAuthorization
StoredValueTransaction is authorized by StoredValueInstrumentActivationAuthorization

Logical Views containing StoredValueInstrumentActivationAuthorization

Logical View
Logical 01420 - Prepaid and Stored Value Payment Instruments
Logical 02500 - Tender Control Transaction - Macro View